Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: syntax error at or near "AND" LINE 1: ...D dm.no= dr1.data_kind_cnt WHERE dm.data_kind = AND dm.no ... ^ in /apps/gmap/gps-disaster/htdocs/db_pgsql.inc on line 65
Database error: Invalid SQL: SELECT dm.*, x(dm.the_geom) AS lon, y(dm.the_geom) AS lat, disaster_sent.manager, disaster_info.meisyou, dr1.picture1, dr1.picture2, dr1.picture3, dr1.picture4, dr1.sent_user, dr1.point_no, dr1.count, dr1.num_files, dr1.extensions, dr1.picture_show FROM disaster_mst as dm LEFT JOIN disaster_sent ON dm.first_sender= disaster_sent.send_user LEFT JOIN disaster_info ON dm.data_kind= disaster_info.id LEFT JOIN disaster_record as dr1 ON dm.data_kind= dr1.data_kind AND dm.no= dr1.data_kind_cnt WHERE dm.data_kind = AND dm.no =" no "
PostgreSQL Error: 1 (ERROR: syntax error at or near "AND" LINE 1: ...D dm.no= dr1.data_kind_cnt WHERE dm.data_kind = AND dm.no ... ^)
Session halted.